agwalsh
asked on
Formula to automatically and dynamically transpose a vertical list to horizontal.
I have a vertical list. See attached file. What formula would I need to use so that the entries are captured horizontally. For example in D5 I have 1/1/2018, in cell G5 I have 1/1/2018. What do I need to use so that if I change the entries in D5 to D20, they automatically update in cells G5 to V5. It's in Sheet 2 of this file.
EE_Date_Sequencev2.xlsx
EE_Date_Sequencev2.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
No, it wont work either in different worksheet nor with table range.
Any update?
ASKER
Thanks as always for another solution!
ASKER