English 中文(简体)
在Excel,我如何把数据作为该栏的新行,将一栏与同一标题合并起来?
原标题:In excel, how do I merge columns with the same header name by adding the data as a new row for that column?

鉴于此表:

以前

“ati”/

How would I merge that so there are only 3 columns: a, b and c with extra data added as new rows? there could be more than a,b,c as column names.

我正试图在Excel创造解决办法。

我正试图这样做。

“result”/

问题回答

你可以尝试

=IFERROR(VSTACK(TOROW(UNIQUE(TOCOL(A1:H1))),DROP(REDUCE("",TOROW(UNIQUE(TOCOL(A1:H1))),LAMBDA(a,x,HSTACK(a,TOCOL(FILTER(A2:H2,A1:H1=x))))),,1)),"")

“entergraph





相关问题
import of excel in SQL imports NULL lines

I have a stored procedure that imports differently formatted workbooks into a database table, does work on them then drops the table. Here is the populating query. SELECT IDENTITY(INT,1,1) AS ID ...

Connecting to Oracle 10g with ODBC from Excel VBA

The following code works. the connection opens fine but recordset.recordCount always returns -1 when there is data in the table. ANd If I try to call any methods/properties on recordset it crashes ...

Excel date to Unix timestamp

Does anyone know how to convert an Excel date to a correct Unix timestamp?

C# GemBox Excel Import Error

I am trying to import an excel file into a data table using GemBox and I keep getting this error: Invalid data value when extracting to DataTable at SourceRowIndex: 1, and SourceColumnIndex: 1. As ...

Importing from excel "applications" using SSIS

I am looking for any tips or resources on importing from excel into a SQL database, but specifically when the information is NOT in column and row format. I am currently doing some pre-development ...

热门标签