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

Conditional concatenation and commas 3
Loop by Group Within Group 6
Copying Sheet1 to Sheet2 in a certain pattern 6
Macro to concatenate columns 1
Macro that analyses 3 columns and put results in 4th 5
Returning same value cell in a column but different row. 4
Compare cells and concatenate on match 2
Returning other cells with the same value in a column, but different row. 1

Top