Format excel data [Closed]

Report
-
Posts
2368
Registration date
Sunday September 23, 2012
Status
Moderator
Last seen
December 13, 2018
-
Hello,

i need to modify the data in my excel. Right now the data looks something like this:

case A
start 51
stop 55
count 1

case B
start 54
stop 67
Count 2


I need it to look like this:


case start stop count
A 51 55 1
B 54 67 2


Please help!

1 reply

Posts
2368
Registration date
Sunday September 23, 2012
Status
Moderator
Last seen
December 13, 2018
19
Greetings!

You can try Transpose feature in excel to do this. Please go through this article in our forum this will help:

Excel - Convert a row into a column and vice-versa

Please do write back to us.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!