•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
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#row zero
#information
#transform
#Name
#family information
#multiple columns
#Dependent Name
#subset
#Relationship
#condense
#DOB
#rows
#columns
#Spouse
#Daughter
#Son