Forum Discussion

Miguel Martinez's avatar
Miguel Martinez
Copper Contributor
Jul 02, 2017

Transpose data conserving links between worksheets

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

BI & Data Analytics
Need Help
  • IngeborgHawighorst's avatar
    IngeborgHawighorst
    MVP
    Jul 03, 2017

    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.

Resources