CODEWITHSUNDEEP
excelvbaexcel-formula
yobab77
yobab77

Reputation: 39

Customize Transposing data

I would like to transpose data to another table so that this table 1 would be transposed. Please see table below.

from this table 1

                day 1           day 2           day 3           day 4   
                value   %       value   %       value   %       value   %
information 1   5694    59.72%  5694    59.72%  5694    59.72%  5678  59.55%

to this table 2 

information 1                               
                day 1   day 2   day 3   day 4               
value           5694    5694    5694    5678                
%               59.72%  59.72%  59.72%  59.55%

Upvotes: 0

Views: 86

Answers (1)

Samantha
Samantha

Reputation: 103

I've done something similar before using the built in formula OFFSET. Create the row and column headings as shown in red below. Then enter the three formulae as show below in the first day column.

screenshot

drag those three formulae and the day numbering across as far as you need.

As some comments have said, you'll get more and better answers if you provide details of what you've tried already and show that you've made an effort before asking the internet. For instance I might have taken the time to explain a little about how OFFSET works and how I figured out what values to give it. As it is... look it up :)

Upvotes: 2

Related Questions