in excel i am importing data from an sql query. i would like to group this data by the first four letters of their sku. sample vtud23 the two numbers on the end denote the color code used for the product. how can I group them by just the first four letters. i would like the quantitys of the similar skus to be totaled. is it posible to do in the query builder some how? or in the sql portion of query builder? or how would i do this? thanks!
M$ query builder and excel
Started by
bemiddy
, Jul 26 2005 11:51 AM
#1
Posted 26 July 2005 - 11:51 AM
bemiddy
-
- Member
-
- 5 posts
New Member
in excel i am importing data from an sql query. i would like to group this data by the first four letters of their sku. sample vtud23 the two numbers on the end denote the color code used for the product. how can I group them by just the first four letters. i would like the quantitys of the similar skus to be totaled. is it posible to do in the query builder some how? or in the sql portion of query builder? or how would i do this? thanks!
#2
Posted 22 December 2006 - 04:53 AM
dsm
-
- Member
-
- 98 posts
Member
bemiddy,
You could add a column titled SKU4
The cells in this column could contain a formula =left(B66,4) to display the first 4 characters.
You could then add a pivot table to count the entries for each SKU4 or calculate the sum of another column for each SKU4.
http://www.wikihow.c...Tables-in-Excel
regards
dsm
You could add a column titled SKU4
The cells in this column could contain a formula =left(B66,4) to display the first 4 characters.
You could then add a pivot table to count the entries for each SKU4 or calculate the sum of another column for each SKU4.
http://www.wikihow.c...Tables-in-Excel
regards
dsm
Similar Topics
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users
As Featured On:
Sign In
Create Account
