Hi.. I'm completely stumped on this one..
I have a worksheet and its grouped by State and City and I have multiple
rows of data for each city to top it off.. State and City are in the same
coloumEg
Virgina
Richmond
Capitol 1
Zoo 2
Bars 10
Maryland
Baltimore
Capitol 1
Zoo 3
Bars 3
College 5
I would like the worksheet to be in
Virignia Richmod Capitol 1
Virgina Richmond Zoo 2
Virgina Richmond Bars 10
Maryland Baltimore Capitol 1
and so on..
Can someone help me..
Thx