wondabread79
New Member
- Joined
- Mar 6, 2013
- Messages
- 1
Hi!
I have a spreadsheet full of data. The first three tabs are considered summary data and the 4th is where the data is pasted from. Data output comes from a SQL query (already made). The output comes out vertically and every cell is linked to the 4th "Data Paste" tab. Yet, I have a request to transpose the data horizontally, yet I am having trouble because all of the cells are linked to numerous formulas (sumifs). I am not too familiar with sumifs and need some guidance on my request! Any bit will help! Thanks.
I have a spreadsheet full of data. The first three tabs are considered summary data and the 4th is where the data is pasted from. Data output comes from a SQL query (already made). The output comes out vertically and every cell is linked to the 4th "Data Paste" tab. Yet, I have a request to transpose the data horizontally, yet I am having trouble because all of the cells are linked to numerous formulas (sumifs). I am not too familiar with sumifs and need some guidance on my request! Any bit will help! Thanks.