CODEWITHSUNDEEP
excelpivottranspose
user1447718
user1447718

Reputation: 681

EXCEL PIVOT Help required

i have data in following data

Id     Status   Value   Line
A-001   1       10      A
A-001   1       20      B
A-001   1       30      C
A-002   2       11      A
A-002   2       12      B
A-002   2       13      C

using pivot, i want to transpose it to

ID    Status    A    B    C    Total
A-001    1     10    20    30    60
A-002    2     11    12    13    36

Thanks in advance.

Upvotes: 0

Views: 49

Answers (1)

teylyn
teylyn

Reputation: 35915

Drag ID and Status to the Rows, Line to the columns and Value to the Values panel.

Then, on the Design ribbon select Report Layout > Show in Tabular Form and Repeat All Item Labels. Remove the row sub-totals and the row grand total.

enter image description here enter image description here

Upvotes: 1

Related Questions