Below is a sample presuming that your data is in an internal excel table. After expanding, then unpivot/merge columns and repivot. The trick is to add an index column during your grouping to get the number of columns. You sound like you were heading in the right direction Carol. I've tried many things using Index, AddingRank, Group then Table.Transpose, Pivot, Unpivot but I don't think I have the correct fields where they should be.

The issue is I don't know how many donors each fund will have so it would have to count the rows first. I'd like to group them by Fund then have each row with new columns. I can then navigate to the location on my computer where I exported the file and view it in Excel.Hi everyone - I've been searching for an answer to do this using Power M but I can't seem to find the correct coding. Right-click in that cell and select the Transpose icon from the Paste Options. *export second dataset to second sheet in Excel*/ Select the new cell where you would like to copy your transposed data. We can use the following code to export both datasets to the same Excel file in different sheets: /*export first dataset to first sheet in Excel*/

Suppose we have two datasets in SAS: /*create first dataset*/ Example 2: Export Multiple Datasets to Multiple Excel Sheets The data in Excel matches the dataset from SAS and the sheet in the Excel workbook is called “First Data” just like I specified in the proc export statement. I can then navigate to the location on my computer where I exported the file and view it in Excel: We can use the following code to export this dataset to an Excel file called my_data.xlsx: /*export dataset*/ Suppose we have the following dataset in SAS: /*create dataset*/ Example 1: Export One Dataset to One Excel Sheet An example formula might be CONCAT (A2, ' Family'). Close the formula with a parenthesis and press Enter. Use commas to separate the cells you are combining and use quotation marks to add spaces, commas, or other text. Select the cell you want to combine first. The following examples show how to use this function in practice. Select the cell where you want to put the combined data. sheet: Name to display on sheet in Excel workbook.replace: Replace the file if it already exists.This procedure uses the following basic syntax: /*export data to file called my_data.xlsx*/

You can use proc export to quickly export data from SAS to an Excel file.

Convert rows to columns in excel