Move data in column into row

MarlonvanDijk

New Member
Joined
Sep 23, 2019
Messages
4
Hello,

I have a large excel-datafile with data stored in columns, but want to get all into one row (this format is needed for further analysis).The dataset is too large to do this manually. Below an example:

Original
Author - Obs.- Obs.- Obs.
X aaa bbb ccc
Y ddd eee

Output
Author - Obs.
X aaa
(X) bbb
(X) ccc
Y ddd
(Y) eee

Preferably I have the author-cell copied in all new columns, but this is not completely necessary. Also note that each column doesn't have the same amount of rows in them.

Is this possible to do in excel? Can it be done by writing a macro? Thanks in advance for your help!
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

MarlonvanDijk

New Member
Joined
Sep 23, 2019
Messages
4
I see the formatting of the example changed. The bold "author" and "Obs" are labels of the rows, with corresponding values in the lines under it
 

Watch MrExcel Video

Forum statistics

Threads
1,108,768
Messages
5,524,787
Members
409,600
Latest member
Dunnowhatfor

This Week's Hot Topics

Top