Transposing this formula ...

vaxo magularia
vaxo magularia used Ask the Experts™
on
Please healp how transpose in yellow range values with formula. With transpose or with other formula...
transpose--1-.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
ShumsManaging Director/Excel VBA Developer
Distinguished Expert 2018

Commented:
Hi,

Please find attached...what will be formula for other row headers?
transpose--1_v1.xlsx

Author

Commented:
Nothing my interest was for first header but are there more easly solution if we delet dollar signs  in row 15 ??
ShumsManaging Director/Excel VBA Developer
Distinguished Expert 2018

Commented:
Have you checked the formula I used?

Author

Commented:
yes it worked but dollar symbols are not neede it must be w x y z
Managing Director/Excel VBA Developer
Distinguished Expert 2018
Commented:
Check again. Dollar symbol was already in your sample workbook, I removed it now.
If you can provide other rows formula within Yellow range, I will fill all.
transpose--1_v2.xlsx

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial