Forum Discussion
Transposing data from a column in one table to another on a different sheet
Hi, I am having issues trying to get the formula to copy across the references in the direction I want them to. Please could you assist. I have a table ("stock") that has the names of stock it...
I think you should look into PivotTables. All those lookups will be slow and cumbersome and PivotTable may expand the way you want. They are a little hard to learn/get used to/format to make them look the way you want, but once you get them right they work well.
I hadn't looked into Pivot Tables before, but had thought there must be a more efficient way to run the calculations. Been self teaching as I've been going.
Thank you for the suggestion.
Thank you for the suggestion.