Transpose data conserving links between worksheets

[Miguel Martinez]

Hello,

I am strugling trying to transpose data while conserving links into a different worksheet. I have been searching on Youtube and forums but I havent found it and I wonder if there is some not to complex possible work around? I am using Excel 2016 in Mac.

Thanks in advance.

Miguel

[#2]

Hello,

how about you share a file or at least a screenshot of the current data, then manually mock up the desired result and explain in context. 

Excel has the Transpose() function. Maybe that could be a starting point.