Hi,
I need to Excel help with how to pull a list of e.g. Airline Carriers from a list of Airports with the data laid out horizontally. The raw data is originally from a pivot table linking to a server.
Any help would be great!
Thanks
example.png
Hi,
I need to Excel help with how to pull a list of e.g. Airline Carriers from a list of Airports with the data laid out horizontally. The raw data is originally from a pivot table linking to a server.
Any help would be great!
Thanks
example.png
I don't think this is viable via a formula.
There is no indication of when the text in column A changes from being an airport to a carrier (and back to an airport for that matter).
You should be able to achieve this via VBA if ALL the airports are in bold.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks