Dec 10, 2014 - Demystifies some of the most challenging of the 300+ formulas and functions in Excel 2011 for the Mac.
Dear Friend, I have been looking for an answer the whole day and have performed every possible solution in the index, transpose, lookup and all the other recommended functions, none of them have worked for me in this case. I have gone through more than 20 posts on the discussion board but all of them were useless. I havent tried your method yet but although I appreciate your help and time, I dont remember forcing you or anyone else to help me, I just looked at posting my question as an option to avoid writing long scripts for such a basic function that is easily available on excel under the special paste option. I thank you very much in advance for the advice. I tried it and with a couple of modifications it worked, thank you very much for making my day 🙂 Message was edited by: cool3pehr.
Hi SG, Not 'wrong,' just incomplete. Table Transpose does the whole table, not a 'single row.' Had Dancin' Brook provided the omitted details of copy, paste, delete rows that are not to be transposed, go Table Transpose, then do whatever needs doing to restore the deleted rows, it would be a fine answer to the original question.
Wayne's response answered the question that was asked with one of the techniques useable at the time. My response to the follow up question addressed that question. Neither response would disturb any existing data except that in the row and column to be transposed. Regards, Barry PS to Dancin' Brook: Will reply later. Time sensitive chores to do now.
HI Dancin' Brook, I saw Sheet 1, which contained a table with data in row 1 and no other data. I didn't see Sheet 2. My assumption is that its table contains the same data in column A, and no other data. For that limited case, the analogous one with the original table containing data only in column A, and the extended case where the original table contains data only in row 1 and in column A, Table Transpose returns what, for all appearances, is a correct result. But Transpose affects the whole table, not just row 1 and column A. Consider, for example, the Source and Receiving tables below: The 'data' in the block B2-J10 was created with a formula, then changed to fixed values by copying the cells then using Paste Formula Results to remove the formulas and leave the last calculated results.
Receiving is a copy of Source, pasted onto a sheet, then supplied the 'general' version of the OFFSET formula above, pasted into A1 and filled right to J1, and separately filled down to A10. Here, the single row (1) and the single column (A) have been transposed. The rest of the data has been left undisturbed. Without the omitted steps described above, Transpose won't do that. Regards, Barry.
Apple Footer. This site contains user submitted content, comments and opinions and is for informational purposes only. Apple may provide or recommend responses as a possible solution based on the information provided; every potential issue may involve several factors not detailed in the conversations captured in an electronic forum and Apple can therefore provide no guarantee as to the efficacy of any proposed solutions on the community forums. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the.