Convert Horizontal Spreadsheet to Vertical

[Barbara7300]

Hello,

I need help converting a Horizontal Excel Spreadsheet to a Vertical Format. It is a rather large spreadsheet with over 1,000 Payees (Sample Spreadsheet attached). Each individual entry "Payee" does not have all of the various "Fees". Viewing this Spreadsheet in a Vertical Format would make it much easier to work with. Any help would be appreciated.

[DJunqueira]

Welcome to the forum.

Converted with Power Query.

Please Login or Register  to view this content.