Previous Topic Next Topic

Format excel data

Closed
ritika dhingra - Updated on Apr 7, 2017 at 09:58 AM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Apr 7, 2017 at 09:42 AM
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

Answer 1 / 1
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 67
Apr 7, 2017 at 09:42 AM
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.
0