3,409 questions
0
votes
0
answers
8
views
Transpose Data Based on Certain Category And Writing Over Same Data
I have the initial data and query like this:
Testing Data
With query, is it possible to make data like in the picture?
This is the data link:
https://docs.google.com/spreadsheets/d/e/2PACX-...
0
votes
1
answer
38
views
Way to transpose a Pandas DataFraa repeated blocks of 4 rows with values in the same column, with dupes [duplicate]
I am trying to transpose 2 columns into 4 rows, but it's been extremely tricky as there is duplicate lines, making pivoting difficult.
What I have is this data as df:
Device Serial Property ...
0
votes
0
answers
27
views
Transpose several columns into one and groupby several columns
I have a dataset which contains two time stamps and several data columns. My aim is to put anything in three columns: two time columns and one data column which results having several rows of ...
- 233
0
votes
0
answers
30
views
Transpose rows to columns in Crystal Reports
I'm new to crystal reports 2020 and need help with getting some data from rows into columns. The report will be exported into excel. Here is an example of the data right out of the table.
ActionID ...
- 1
1
vote
0
answers
70
views
How to efficiently multiply a vector by a transposed sparse matrix in Eigen?
I have with a sparse matrix A and a vector x in Eigen, and I need to perform the following transposed matrix × matrix × vector operation: ATAx. This can be decomposed into two matrix-vector ...
- 23.7k
-1
votes
1
answer
74
views
Mainframe Sort JCL - transpose the rows to column
I have the following input:
.TY records can vary from 1 to 30 times
I tried with build & PUSH in sort but i couldn't get the expected below output
I need to get it using SORT not COBOL.
The BEGIN ...
- 9
0
votes
1
answer
54
views
Cell conditioning based on cell value on a row to cell value on column
Above is the cell values I want to apply the condition too.
A solution that works is to create a new column using the transpose function for the row in Question is to use the cell = cell.
I dont want ...
0
votes
2
answers
67
views
Excel. How to get an one row data (multiple columns) from every three rows
Please need your help.
I have an excel file with this following structure, that one row is divided into the next two rows:
initial
And need finally get this one. Every third row need to be combined ...
0
votes
4
answers
106
views
Reformat data so repeating value is column header and data is row
I have a column with values that repeat and need the unique values to be column headers. Then, I need to add the associated data as a row. I have 20k of these rows and cannot figure out how to ...
- 3
-2
votes
2
answers
60
views
Edit row and column names in a transposed data frame
I have a dataframe that I have successfully transposed using the t function present in base R. However I'd like to change the column names and row names to be part of the dataframe. I'll use the iris ...
- 2,129
0
votes
0
answers
80
views
C code for fusing multiple array transpositions into one pass
Suppose that A is a one-dimensional NumPy array and s, n_y, n_x,
blk_y, and blk_x are integers > 0 and s divides both blk_y and
blk_x. The number of elements in A is equal to both n*s*s and
ny*...
- 20.5k
0
votes
3
answers
77
views
Excel VBA to transpose a sets of rows to columns. Each set of rows may not be of the same size
I have a example table with 3 columns (Sample, Index, Value). In this example, there are 12 samples, 3 possible Index and for each of them a Value. I would like to transpose to columns the Value by ...
0
votes
1
answer
52
views
Transposing multiple values columns in Pandas
I have the following pandas dataframe and I would like to transpose it.
YEAR
CD_PRD
VL_JAN
VL_FEB
VL_MAR
VL_APR
2022
CD76
10000
8000
170000
58000
2022
CD92
15000
7500
86000
1200
2023
CD76
8000
12000
...
- 391
0
votes
1
answer
93
views
SQL: Data Transpose
I have a SQL script that outputs this:
timestamp
tagname
value
12/19/2024 15:00:57
RUNNING
0
12/19/2024 15:00:55
RUNNING
1
12/19/2024 14:53:38
RUNNING
0
12/19/2024 14:53:35
RUNNING
1
12/19/2024 14:53:...
- 89
1
vote
2
answers
59
views
How to convert values from columns to rows
Order ID
Customer Name
Email Address
Product 1 - Brand
Product 1 - Description
Product 1 - Price
Product 2 - Brand
Product 2 - Description
Product 2 - Price
123
John Smith
[email protected]
Carrier
...
- 13