How to Swap Rows and Columns in Excel
In Cue Office, use Paste Special → Transpose to swap rows and columns in an Excel workbook for a finished report. For an attendance sheet you still update, use Cue AI to create a transposed table that follows changes to the original.
Swap rows and columns with Paste Special
Open your sign-in workbook (.xlsx) in Cue Office, select A1:E4, and copy it, including the weekdays in the first row and the workshop names in the first column. A 4-row, 5-column range will occupy 5 rows and 4 columns after transposition. First confirm that A7:D11 is blank, then click top-left cell A7.
Click the Home tab at the top, expand the Paste Special drop-down menu, and click Paste Special…. In the dialog that appears, check Transpose and click OK.
Check the transposed table
Save and reopen the workbook. Weekdays should run down the left, with workshop names across the top. On Monday, 12 people attended the Repair workshop. That count is in B2 in the original and B8 in the transposed table.
For the text and numbers in this example, Paste Special creates a snapshot. If you change B2 to 99 later, the pasted B8 stays at 12.
Create a transposed table that updates with Cue AI
While an event is still ongoing, colleagues may want to see the latest attendance by day. Open another copy of the original table and keep A7:D11 blank to leave room for the linked table.
Under Home, click Cue AI and send the prompt below.
Could you turn the rows in A1:E4 into columns and put the new table starting at A7? I’d like the new table to update when I edit the original, and please keep the original table as it is.
Cue AI entered =TRANSPOSE(A1:E4) in A7. The formula fills A7:D11. Save, close, and reopen the workbook, then select A7 and check the formula bar. Change Monday’s Repair count in B2 from 12 to 99. B8 should update to 99. When you’re done checking, type 12 back into B2 and save.
Practice with four days of sign-in data
Expand sign-in sheet
Save the content below as a CSV, open it in Cue Office, and save it as XLSX. The original table occupies A1:E4, leaving A7 free for practicing transposition.
Workshop,Monday,Tuesday,Wednesday,Thursday Repair,12,18,15,20 Bike clinic,9,11,14,13 Tool orientation,16,13,19,17
From sign-in sheets to daily reporting
During the workshop, staff can log attendance by activity and use the linked view to send a daily count to colleagues. If the next session runs an extra day, give Cue AI the expanded source range and an empty destination, then spot-check the new day’s counts.
Cue Office is a free office suite. Use it to view event schedules in PDF, edit attendance workbooks in Excel (.xlsx), write handover notes in Word (.docx), and share attendance figures in PowerPoint (.pptx).