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

Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
68
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