something_like_transpose

G

gbelo

how easily convert the follow situation

date1 date2 date3 datex
name1 a1 a2 a3 a4
name2 b1 b2 b3 b4
name3 c1 c2 c3 c4


namen d1 d2 d3 d4

to this

date1 name1 a1
date2 name1 a2
date3 name1 a3
datex name1 a4
date1 name1 b1
date2 name2 b2
date3 name2 b3
datex name2 b4
date1 namen c1
date2 namen c2
date3 namen c3
datex namen c4
date1 namen d1
date2 namen d2
date3 namen d3
datex namen d4



thank you
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA for summing buys and sells 0
Loop by Group Within Group 6
Copying Sheet1 to Sheet2 in a certain pattern 6
Macro to concatenate columns 3
VBA Coding Help for Beginner 0
Find Duplicate names and delete problem 2
Macro that analyses 3 columns and put results in 4th 5
Fill cells based on the other 3 cells unique combination the value on the target cell 0

Top