A macro that expands and outputs a horizontal table into a vertical table based on the specifications "Effective Cell" series Vertical expansion macro (multi-classification hierarchy compatible version) For business use
EC Research Institute Co., Ltd.
About This Product
This macro expands a horizontal table into a vertical table based on the specifications and outputs it to the specified location. Since it supports multiple classification, you can return to the table created by pivoting.
■Processing overview
Horizontal tables are difficult to analyze, process, and reuse, even though they are often used on a daily basis, and the macros are also complex. For example, reprocessing pivot output tables, data from other software, data received from other companies, etc.
・Easy handling by unfolding vertically.
・Since it supports multiple classification, data divided into multiple classifications can be developed vertically.
- Vertical expansion columns can be specified visually.
・Method of importing and setting sample rows - For working with multiple data.
Features
■Vertical expansion columns can be specified visually
- A method is adopted in which a part of the target data (3 lines) is imported into the operation sheet as a sample line, and then specified for the imported data.
・Visual specification becomes possible.
■A wide variety of output specifications
Columns that can be output
- Vertically expanded values, specified columns, specified rows, classification lines, row numbers, column numbers, sequential numbers, book names, sheet names, fixed values, etc.
・Supports various needs regarding vertical unfolding processing.
■ Error values, blank fields, zeros, etc. can be skipped.
Reduces the hassle of re-correcting after vertical deployment.
■Automatically responds to changes in the number of lines
There is no need to change settings even if the number of data rows changes.
Especially recommended for those who:
■Those who are working on rolling out vertically.
Vertical unfolding work becomes easy, accurate, and effortless.
■Those who analyze, process, and reuse horizontal tables
Sorting and pivoting are now available, making analysis, processing, and reuse easier.
■Those who are creating macros that handle horizontal tables
- Macros become simple and easy.
・If macros become simpler, design, development, and testing become easier.
- Shorter time and fewer bugs.
■Those who perform regular work and those who design the structure of regular work
Horizontal tables are easier to handle, improving productivity and quality for members.
-
Product
A macro that expands and outputs a horizontal table into a vertical table based on the specifications "Effective Cell" series Vertical expansion macro (multi-classification hierarchy compatible version) For business use
-
Handling Company
EC Research Institute Co., Ltd.
-
Categories
1 Models of A macro that expands and outputs a horizontal table into a vertical table based on the specifications "Effective Cell" series Vertical expansion macro (multi-classification hierarchy compatible version) For business use
| Product Image | Part Number | Price (excluding tax) |
|---|---|---|
|
|
Vertical expansion macro (multiple classification hierarchy compatible version) for business use |
Available upon quote |
Customers who viewed this product also viewed
Other products of EC Research Institute Co., Ltd.
View more products of EC Research Institute Co., Ltd.
