Hi Everyone, I' ve been searching threads to convert multiple rows with same items to single column Header and get subsequent data related to items.Have huge data in multiple rows and column, Kindly provide a solution to convert multiple same data rows into columns as below.
Have attached sample file
Original data:
Fruit(ColA) - Location(ColD)
Apple - Texas5
Apple - cali.6
Apple - Ohio.new
Orange - buffalo
Apple - Texas7
orange - Japan
Orange - SA
Grapes - India
Orange - Srilanka
grapes - Texas4
Grapes - Washington
Blank - seatle
Desired Output reqd :
Apple(ColA) - Orange(ColB) - Grapes(ColC) - Blank(ColD)
Texas5 - buffalo - India - Seatle
cali.6 - Japan - Texas4
Ohio.new - SA - Washington
Texas7 - Srilanka
Have attached sample file
Original data:
Fruit(ColA) - Location(ColD)
Apple - Texas5
Apple - cali.6
Apple - Ohio.new
Orange - buffalo
Apple - Texas7
orange - Japan
Orange - SA
Grapes - India
Orange - Srilanka
grapes - Texas4
Grapes - Washington
Blank - seatle
Desired Output reqd :
Apple(ColA) - Orange(ColB) - Grapes(ColC) - Blank(ColD)
Texas5 - buffalo - India - Seatle
cali.6 - Japan - Texas4
Ohio.new - SA - Washington
Texas7 - Srilanka