Format excel data [Closed]

Question

Format excel data [Closed]

Report

ritika dhingra - Updated on Apr 7, 2017 at 09:58 AM
Zohaib R

Posts: 2368
Registration date: Sunday September 23, 2012
Status: Moderator
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!

Ask a question

Zohaib R · Answer 1 · 2017-04-07T09:42:57-0400

Answer 1 / 1

Zohaib R

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

19
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.

Format excel data [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!