Link to home
Get AccessLog in
Avatar of GPSPOW
GPSPOWFlag for United States of America

asked on

Convert columnar data table to row data

I have an excel budget table with account numbers as rows and period dates as columns.  I want to convert the table so that there are 12 rows for each of the 1100 account numbers.  Column A would be the Account Number, Column B the Period Ending Date and Column C the budgeted value for that account and period.  If the period value is blank, the value would be zero.

Is there an easy way to do this via VBA?

Thanks

Glen
Avatar of Saurabh Singh Teotia
Saurabh Singh Teotia
Flag of India image

Can you post your sample file to have a look...with what you are trying to do...

Saurabh...
Avatar of GPSPOW

ASKER

Attached is snippet of the budget format.

Each account number should have 12 rows of data.  One for each month.

thanks

glen
Budget.xlsx
Glen,

Quick question if the period value is blank or zero? You still want to see that entry with combination of the account or you don't want to see that??

Saurabh...
Avatar of GPSPOW

ASKER

If the value is blank or zero, use zero.

Thanks

Glen
ASKER CERTIFIED SOLUTION
Avatar of Saurabh Singh Teotia
Saurabh Singh Teotia
Flag of India image

Link to home
membership
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access
Avatar of GPSPOW

ASKER

Thank you