CODEWITHSUNDEEP
excel
Rod
Rod

Reputation: 15455

transform excel format

Environment: Microsoft Excel 2003, 07, or 10

Is there an easy way to transform

lines 1-11

into 

lines 15-20

enter image description here

Upvotes: 0

Views: 52

Answers (1)

Zeugma
Zeugma

Reputation: 32095

This can be easily done with few additional basic test formulas.

Add the columns in your table as per the screenshot below and filter your table with is_id column TRUE data.

Enjoy, you're welcome.

enter image description here

Upvotes: 1

Related Questions