•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How do I pull condense multiple rows of information into 1 row and multiple columns?
So I need to transform a certain subset of information into multiple columns. Example
Name: Dependent Name: Relationship: DOB
John doe: Jane Doe: Spouse: 01/01/70
John doe: Janet Doe: Daughter: 01/01/00
John doe: John Doe Jr: Son: 01/01/00
To read:
John Doe : Jane Doe: Spouse: 01/01/70: Janet Doe: Daughter: 01/01/00: John Doe Jr: Son: 01/01/00
The idea is to get all family information out of multiple columns and into 1 column.
Any ideas? Thank you kindly!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com